<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<link rel="stylesheet" type="text/css" href="public/css.css"> 

<form method="POST">
    Keyword  : <input type="text" name="likes"><br>
    Min likes &nbsp;: <input type="text" name="likesMin"><br>
    Max likes : <input type="text" name="likeMax"><br>
    <input type="submit" name="submit" value="Search">
</form>
<?php
require_once './model/db.php';
$query = "SELECT * FROM pages LIMIT 10;";
$pages = getFilms($query);
?>






<table id="table1" border="1px">
    <tr class="khung">
        <td class="pid">STT </td>
        <td class="id">id </td>
        <td class="name">name </td>
        <td class="picture">picture </td>
        <td class="likes">likes </td>
        <td class="talking">talking</td>
        <td class="category">category </td>
        <td class="link">link </td>
        <td class="website">website </td>
        <td class="country">country </td>
    </tr>
    <?php foreach ($pages as $page): ?>
            <tr>
                <td><?php echo $page["pid"] ?></td>
                <td><?php echo $page["id"] ?></td>
                <td><?php echo $page["name"] ?></td>
                <td><img src='<?php echo $page["picture"]?>'</td>
                <td><?php echo $page["likes"] ?></td>
                <td><?php echo $page["talking_about_count"] ?></td>
                <td><?php echo $page["category"] ?></td>
                <td><a href="<?php echo $page["link"]?>"><?php echo $page["link"]?></td>
                <td><a href="<?php echo $page['website']?>"><?php echo $page['website']?></td>
                
                <td><?php echo $page["country"] ?></td>
       </tr>
       

    <?php endforeach; ?>
</table>

    